package com.zq.ssmdemo.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zq.ssmdemo.pojo.Positions;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Update;

/**
 * <p>
 * 职位信息表 Mapper 接口
 * </p>
 *
 * @author 张乔
 * @since 2024-06-09
 */
@Mapper
public interface PositionsMapper  extends BaseMapper<Positions> {

    @Update("update positions\n" +
            "set position_name=#{positionName},Description=#{Description}\n" +
            "where Position_id = #{PositionId};\n")
    void updateByIdssss(Positions positions);

    @Delete("delete from positions where Position_id = #{id}")
    void deleteByIdssss(Integer id);
}
